Notes/Domino 6 and 7 Forum : RE: dblookup and dbcolumn

Notes/Domino 6 and 7 Forum

RE: dblookup and dbcolumn

RE: dblookup and dbcolumn
Posted by ~Yentl Kifreeterynds on 21.Jan.04 at 04:52 PM using a Web browser
Category: Domino Designer

Release: 6.0.2 CF2

Platform: Windows XP

Hi,

First of all, you should index your database and categorize your first column in your view.

First field formula is :
@DbColumn("Notes":"Nocache";"":"";View Name;1)
Return : "Chicago":"New York"

Second Field formula is :
TMP:=@DbLookup("Notes":"NoCache";"":"";View name;First Field;2);
@If(@IsError(TMP);"";TMP)
Return : "001" : "002" : "003" .....

I hope this help..